SELECT ident, naziv,IF( slika_1 IS NULL ,'/gfx/_box-images/ni_slike.jpg',slika_1) as slika_1,cena_pred_akcijo,cena FROM _produkti_aures
WHERE kategorija = 'Čelade Airoh' AND pod_kategorija = 'Integralne'
ORDER BY cena LIMIT 18,9
Airoh ST501 SQUARE BLACK MATT
319,99 €
Airoh ST501 SQUARE PINK MATT
319,99 €
Airoh ST501 DOCK YELLOW MATT
319,99 €
Airoh ST501 Type
319,99 €
Airoh ST501 DOCK ORANGE MATT
319,99 €
Airoh ST501 DOCK RED GLOSS
319,99 €
Airoh Matryx Color bela
359,99 €
Airoh Matryx Color črna
359,99 €
Airoh Matryx Scope Yellow matt
389,99 €